In one corner we have Sql server; in the other, an older minicomputer. I used a third party connector to pull data from the minicomputer into sql, massaged it using t-sql, and now want to update selected records on the mini based on the sql tables. (If the mini were a sql server this last step would be nothing more than a sql statement involving a join.) I'm having trouble finding the right SSIS Source\Destination to do the job. The fundamental issue is that to update the mini I need to do a join between data on the sql and mini and every SSIS Source I've tried scoffs at that attempt. I can find Sources for Sql or the Mini but not one that supports both. Any ideas much appreciated? Barkingdog

You can link the both. Or use openrowset. Configuring Linked Servers: http://msdn.microsoft.com/en-us/library/aa213778%28v=sql.80%29.aspxArthur My Blog

Ooops. Per the URL, OpenRowSet "Includes all connection information that is required to access remote data from an OLE DB data source. " My source (the mini) only supports ODBC not OLE DB. (Does the OLE DB Provider for ODBC still exist in sql 2008?) Barkingdog

Yes http://msdn.microsoft.com/en-us/library/ms191462(v=SQL.100).aspx Jeff Wharton MSysDev (C.Sturt), MDbDsgnMgt (C.Sturt)